Business objects are user-friendly abstractions and collections of data from the iMIS tables. These abstractions let you write powerful queries and reports safely, without needing to be intimately familiar with the iMIS database schema.
In most cases, the business object name and the names of its various properties are suggestive enough to guide experimentation. At times, however, it can be useful to trace the properties of a business object to their underlying table columns.
To trace business object properties to their underlying table data
1. From Tools, select Business object designer.
2. Double-click the business object that you want to examine.
3. On the Properties tab, select the property that you want to trace.
4. In the lower set of tabs, in the Definition tab, the Database Table and Database Column fields specify the table and column from which the property derives its data.
5. (optional) It can also be useful to examine the table joins used in a business object that comprises multiple tables.
□ In the upper set of tabs, in the Database tab, examine the Joins field.
Note: All joins in a business object are inner joins.